84e1e12b66a3eb51a763cca2554b82ddeba1daa0,src/test/java/org/tests/query/orderby/TestOrderByWithDistinct.java,TestOrderByWithDistinct,test,#,41

Before Change


    Assert.assertEquals(1, list.size());
    Assert.assertEquals(user1, list.get(0));
    String generatedSql = query.getGeneratedSql();
    Assert.assertTrue(generatedSql.contains("select distinct t0.userid")); // using distinct
    Assert.assertTrue(generatedSql.contains("order by t1.name,")); // name in order by
    Assert.assertTrue(generatedSql.contains("t1.name"));// name in select

After Change


    // order by t1.name; --bind(A)

    generatedSql = query.getGeneratedSql();
    if (isPostgres()) {
      assertThat(generatedSql).contains("select distinct on (t1.name, t0.userid) t0.userid"); // using distinct
    } else {
      assertThat(generatedSql).contains("select distinct t0.userid"); // using distinct
    }
    assertThat(generatedSql).contains("order by t1.name"); // name in order by
    assertThat(generatedSql).contains("t1.name");// name in select